package com.godtree.mybatisplus.method;

import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.core.enums.SqlMethod;
import com.baomidou.mybatisplus.core.injector.AbstractMethod;
import com.baomidou.mybatisplus.core.metadata.TableInfo;
import com.baomidou.mybatisplus.core.metadata.TableInfoHelper;
import com.baomidou.mybatisplus.core.toolkit.Constants;
import com.baomidou.mybatisplus.core.toolkit.StringUtils;
import com.baomidou.mybatisplus.core.toolkit.sql.SqlScriptUtils;
import com.godtree.mybatisplus.enums.MySqlMethod;
import org.apache.ibatis.executor.keygen.Jdbc3KeyGenerator;
import org.apache.ibatis.executor.keygen.KeyGenerator;
import org.apache.ibatis.executor.keygen.NoKeyGenerator;
import org.apache.ibatis.mapping.MappedStatement;
import org.apache.ibatis.mapping.SqlSource;

/**
 * 插入一条数据（重复存在更新）（非空判断）
 *
 * @author lisicheng
 * @date 2023-05-05
 */
public class InsertOnDuplicateKeyUpdate extends AbstractMethod {

  @Override
  public MappedStatement injectMappedStatement(Class<?> mapperClass, Class<?> modelClass,
      TableInfo tableInfo) {
    KeyGenerator keyGenerator = new NoKeyGenerator();
    MySqlMethod sqlMethod = MySqlMethod.INSERT_ON_DUPLICATE_KEY_UPDATE;
    String columnScript =
        SqlScriptUtils.convertTrim(tableInfo.getAllInsertSqlColumnMaybeIf(Constants.ENTITY_DOT),
            LEFT_BRACKET,
            RIGHT_BRACKET, null, COMMA);
    String valuesScript =
        SqlScriptUtils.convertTrim(tableInfo.getAllInsertSqlPropertyMaybeIf(Constants.ENTITY_DOT),
            LEFT_BRACKET,
            RIGHT_BRACKET, null, COMMA);
    // 根据 whereEntity 条件，更新记录
    String duplicateKeyUpdateScript =
        SqlScriptUtils.convertTrim(
            tableInfo.getAllSqlSet(tableInfo.isWithLogicDelete(), Constants.ENTITY_DOT),
            null, null, null, COMMA);

    String sqlScript = String.format("`${%s}` = ${%s}", "key", "value");
    sqlScript = SqlScriptUtils.convertForeach(sqlScript, Constants.COLUMN_MAP, "key", "value",
        COMMA);
    sqlScript = SqlScriptUtils.convertChoose(
        String.format("%s != null and %s.size() > 0", Constants.COLUMN_MAP, Constants.COLUMN_MAP),
        sqlScript,
        duplicateKeyUpdateScript);
    duplicateKeyUpdateScript = NEWLINE + sqlScript;

    String keyProperty = null;
    String keyColumn = null;
    // 表包含主键处理逻辑,如果不包含主键当普通字段处理
    if (StringUtils.isNotBlank(tableInfo.getKeyProperty())) {
      if (tableInfo.getIdType() == IdType.AUTO) {
        // 自增主键
        keyGenerator = new Jdbc3KeyGenerator();
        keyProperty = Constants.ENTITY_DOT + tableInfo.getKeyProperty();
        keyColumn = tableInfo.getKeyColumn();
      } else {
        if (null != tableInfo.getKeySequence()) {
          keyGenerator = TableInfoHelper.genKeyGenerator(sqlMethod.getMethod(), tableInfo,
              builderAssistant);
          keyProperty = tableInfo.getKeyProperty();
          keyColumn = tableInfo.getKeyColumn();
        }
      }
    }
    String sql = String.format(sqlMethod.getSql(), tableInfo.getTableName(), columnScript,
        valuesScript,
        duplicateKeyUpdateScript);
    SqlSource sqlSource = languageDriver.createSqlSource(configuration, sql, modelClass);
    return this.addInsertMappedStatement(mapperClass, modelClass, sqlMethod.getMethod(), sqlSource,
        keyGenerator,
        keyProperty, keyColumn);
  }

  @Override
  public String getMethod(SqlMethod sqlMethod) {
    return "insertOnDuplicateKeyUpdate";
  }
}
